Using the Summary command

1. Select the field that you want to summarize.
2. Choose the Summary command from the Insert menu. The Insert Summary dialog box appears.
3. Select a calculation option from the first list.
4. The second list contains a list of the fields and formulas being used in the report. Click the arrow button to reveal the list, and select from that list the field that you want the program to use for triggering summaries.
   • The program will first sort report data based on this field.
   • Then it will go down the report grouping and summarizing the data whenever the value in the sort-and-group-by field (the trigger field) changes.
   • If you select a date or Boolean field, you can further narrow your selection.
5. The next scroll box lists the four sort directions.

   The default direction is ascending order. If you want to change the sort direction, click the scroll arrow to reveal the options and then select one of them.

6. Click OK. The program sorts, groups, and summarizes your data, and then places the summary in the group section of your report. You can then move it to the desired position.

Related topics

Summary command